﻿CREATE TABLE [dbo].[Order_Tbl] (
    [OrderID]             INT            NOT NULL,
    [ExtraOrderNo]        INT            NULL,
    [QuoteID]             INT            NULL,
    [Salesman]            NVARCHAR (50)  NULL,
    [FirstName]           NVARCHAR (50)  NULL,
    [LastName]            NVARCHAR (50)  NULL,
    [BoatType]            NVARCHAR (MAX) NULL,
    [BoatName]            NVARCHAR (MAX) NULL,
    [WorksOrderNumber]    NVARCHAR (50)  NULL,
    [LOA]                 INT            NULL,
    [DeliveryWeek]        INT            NULL,
    [QuoteDateCreated]    NVARCHAR (50)  NULL,
    [MarketID]            INT            NULL,
    [I]                   FLOAT          NULL,
    [J]                   FLOAT          NULL,
    [P]                   FLOAT          NULL,
    [E]                   FLOAT          NULL,
    [CurrencyID]          INT            NULL,
    [BoatStyleID]         INT            NULL,
    [Address1]            NVARCHAR (MAX) NULL,
    [Address2]            NVARCHAR (50)  NULL,
    [Address3]            NVARCHAR (50)  NULL,
    [PostCode]            NVARCHAR (50)  NULL,
    [City]                NVARCHAR (50)  NULL,
    [CountryID]           INT            NULL,
    [DeliveryMonth]       INT            NULL,
    [Notes]               NTEXT          NULL,
    [Telephone]           NVARCHAR (50)  NULL,
    [Fax]                 NVARCHAR (50)  NULL,
    [Email]               NVARCHAR (50)  NULL,
    [VAT]                 FLOAT          NULL,
    [OrderDateCreated]    NVARCHAR (50)  NULL,
    [OrderDestinationID]  INT            NULL,
    [DepositPercent]      FLOAT          NULL,
    [DepositRequired]     FLOAT          NULL,
    [DepositReceived]     FLOAT          NULL,
    [DepositBalance]      FLOAT          NULL,
    [Balance]             FLOAT          NULL,
    [Accepted]            BIT            NULL,
    [TotalValue]          FLOAT          NULL,
    [OfferedValue]        FLOAT          NULL,
    [HQSalesman]          NVARCHAR (50)  NULL,
    [CookieID]            INT            NULL,
    [CustomerID]          INT            NULL,
    [MeasurementID]       INT            NULL,
    [ShippingCosts]       FLOAT          NULL,
    [RefSalesman]         NVARCHAR (50)  NULL,
    [BoatGenID]           INT            NULL,
    [OEMOrder]            BIT            NULL,
    [DeliveryDate]        NVARCHAR (20)  NULL,
    [WorksOrderNumber2]   NVARCHAR (255) NULL,
    [NewDeliveryAddress]  BIT            NULL,
    [ClearedFlag]         INT            NULL,
    [StandardSailQuote]   BIT            NULL,
    [NotestoAX]           BIT            NULL,
    [ISp]                 FLOAT          NULL,
    [Spl]                 FLOAT          NULL,
    [Ey]                  FLOAT          NULL,
    [Py]                  FLOAT          NULL,
    [ImportToProdCard]    BIT            NULL,
    [SailNumber]          NVARCHAR (50)  NULL,
    [SailNumberColourID]  INT            NULL,
    [DraftStripeColourID] INT            NULL,
    [RuleID]              INT            NULL,
    [RigType]             NVARCHAR (50)  NULL,
    [Runners]             BIT            NULL,
    [Checkstays]          BIT            NULL,
    [DateCancelled]       NVARCHAR (50)  NULL,
    [DateUpdated]         NVARCHAR (50)  NULL,
    [DesignStarted]       BIT            NULL,
    [EndDiscountValue]    FLOAT          NULL,
    [Stl]                 FLOAT          NULL,
    [Failed]              BIT            NULL,
    [DesignPrint]         NVARCHAR (50)  NULL,
    [DelDate]             DATETIME       NULL,
    [DateCreated]         DATETIME       NULL
);

